select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Cheap Four-Tier Cut Edge Drop Veil Wedding Veils
Multi-Tier Pencil Edge Elbow Bridal Veils Whites Bridal Veils
2014 Simple Four-Tier Bridal Veils with Lace Appliques Edge
2014 Simple One-Tier Bridal Veils with Lace Appliques Edge
Fuchsia Sweetheart Princesita Dress with Beading and Ruffles
Orange Red Barbie Doll Dress with Appliques and Hand Made Followers
White Dress For Barbie Doll with Appliques On Quinceanera Party
White Barbie Doll Dress with Appliques and Rolling Followers
Purple Dress Made to Fit the Barbie Doll with Appliques
White Quinceanera Dress For Barbie Doll with Appliques
Red Barbie Doll Dress with Appliques and Pick-ups
Yellow Green Quinceanera Dress For Barbie Doll with Appliques and Ruffles
Multi-color Barbie Doll Dress with Beading and Ruffles
Blue Quinceanera Dress For Barbie Doll with Beading and Ruffled Layers
Navy Blue Quinceanera Dress For Barbie Doll with Appliques and Hand Made Flowers
Baby Pink Quinceanera Dress For Barbie Doll with Beading
White Barbie Doll Dress with Beading and Ruffles
Hot Pink Gown for Barbie Doll with Beading and Ruffles
Hot Pink Barbie Doll Dress with Beading and Ruffles
Baby Pink Quinceanera Dress For Barbie Doll with Beading and Ruffles
Haltr Top Red Barbie Doll Dress for Quinceanera Party
Blue Quinceanera Dress For Barbie Doll with Beading and Ruffles
Purple Dress Made to Fit the Barbie Doll with Appliques and Ruffles
Multi-color Barbie Doll Dress with Beading and Pick-ups
Blue Dress For Barbie Doll with Appliques On Quinceanera Party
Blue Dress for Noble Barbie with Beading and Ruffles
Pink Quinceanera Dress For Barbie Doll with Beading and Ruffles
Muti-color Quinceanera Dress For Barbie Doll with Ruffles
Muti-color Quinceanera Dress For Barbie Doll with Ruffles
Turquiose Quinceanera Dress For Barbie Doll with Ruffles and Beading